###### Importing necessary libraries:-
library(dplyr)
## Warning: package 'dplyr' was built under R version 4.2.2
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
library(ggplot2)
pl <- read.csv(file.choose()) # Open CSv File
#####Glance Of dataSet
head(pl)
## sl_no gender ssc_p ssc_b hsc_p hsc_b hsc_s degree_p degree_t workex
## 1 1 M 67.00 Others 91.00 Others Commerce 58.00 Sci&Tech No
## 2 2 M 79.33 Central 78.33 Others Science 77.48 Sci&Tech Yes
## 3 3 M 65.00 Central 68.00 Central Arts 64.00 Comm&Mgmt No
## 4 4 M 56.00 Central 52.00 Central Science 52.00 Sci&Tech No
## 5 5 M 85.80 Central 73.60 Central Commerce 73.30 Comm&Mgmt No
## 6 6 M 55.00 Others 49.80 Others Science 67.25 Sci&Tech Yes
## etest_p specialisation mba_p status salary
## 1 55.0 Mkt&HR 58.80 Placed 270000
## 2 86.5 Mkt&Fin 66.28 Placed 200000
## 3 75.0 Mkt&Fin 57.80 Placed 250000
## 4 66.0 Mkt&HR 59.43 Not Placed NA
## 5 96.8 Mkt&Fin 55.50 Placed 425000
## 6 55.0 Mkt&Fin 51.58 Not Placed NA
####About Data Set:
##A University Announced Its On-Campus Placement Records For The Mba Course. The Data Is From The Years 2013 And 2014.The Following Is The College Placements Data Compiled Over 2 years.
##This Dataset Consists of 15 columns which include gender,ssc percentage,hsc percentage,ssc board,hsc board,work experiance,degree percentage ,degree technology,test percentage,specilization,mba percentage,status,salary
####check for missing values:
sapply(pl, function (x){sum(is.na(x))})
## sl_no gender ssc_p ssc_b hsc_p
## 0 0 0 0 0
## hsc_b hsc_s degree_p degree_t workex
## 0 0 0 0 0
## etest_p specialisation mba_p status salary
## 0 0 0 0 67
##we Can Observe there are missing values in salary column
##Handling missing data:
pl[complete.cases(pl), ]
## sl_no gender ssc_p ssc_b hsc_p hsc_b hsc_s degree_p degree_t workex
## 1 1 M 67.00 Others 91.00 Others Commerce 58.00 Sci&Tech No
## 2 2 M 79.33 Central 78.33 Others Science 77.48 Sci&Tech Yes
## 3 3 M 65.00 Central 68.00 Central Arts 64.00 Comm&Mgmt No
## 5 5 M 85.80 Central 73.60 Central Commerce 73.30 Comm&Mgmt No
## 8 8 M 82.00 Central 64.00 Central Science 66.00 Sci&Tech Yes
## 9 9 M 73.00 Central 79.00 Central Commerce 72.00 Comm&Mgmt No
## 11 11 M 58.00 Central 61.00 Central Commerce 60.00 Comm&Mgmt Yes
## 12 12 M 69.60 Central 68.40 Central Commerce 78.30 Comm&Mgmt Yes
## 14 14 F 77.00 Central 87.00 Central Commerce 59.00 Comm&Mgmt No
## 16 16 F 65.00 Central 75.00 Central Commerce 69.00 Comm&Mgmt Yes
## 17 17 M 63.00 Central 66.20 Central Commerce 65.60 Comm&Mgmt Yes
## 20 20 M 60.00 Others 67.00 Others Arts 70.00 Comm&Mgmt Yes
## 21 21 M 62.00 Others 65.00 Others Commerce 66.00 Comm&Mgmt No
## 22 22 F 79.00 Others 76.00 Others Commerce 85.00 Comm&Mgmt No
## 23 23 F 69.80 Others 60.80 Others Science 72.23 Sci&Tech No
## 24 24 F 77.40 Others 60.00 Others Science 64.74 Sci&Tech Yes
## 25 25 M 76.50 Others 97.70 Others Science 78.86 Sci&Tech No
## 27 27 M 71.00 Others 79.00 Others Commerce 66.00 Comm&Mgmt Yes
## 28 28 M 63.00 Others 67.00 Others Commerce 66.00 Comm&Mgmt No
## 29 29 M 76.76 Others 76.50 Others Commerce 67.50 Comm&Mgmt Yes
## 31 31 F 64.00 Central 73.50 Central Commerce 73.00 Comm&Mgmt No
## 33 33 F 61.00 Central 81.00 Central Commerce 66.40 Comm&Mgmt No
## 34 34 F 87.00 Others 65.00 Others Science 81.00 Comm&Mgmt Yes
## 36 36 F 69.00 Central 78.00 Central Commerce 72.00 Comm&Mgmt No
## 38 38 F 79.00 Central 76.00 Central Science 65.60 Sci&Tech No
## 39 39 F 73.00 Others 58.00 Others Science 66.00 Comm&Mgmt No
## 40 40 M 81.00 Others 68.00 Others Science 64.00 Sci&Tech No
## 41 41 F 78.00 Central 77.00 Others Commerce 80.00 Comm&Mgmt No
## 44 44 M 87.00 Others 87.00 Others Commerce 68.00 Comm&Mgmt No
## 45 45 F 77.00 Others 73.00 Others Commerce 81.00 Comm&Mgmt Yes
## 48 48 M 63.00 Central 60.00 Central Commerce 57.00 Comm&Mgmt Yes
## 49 49 M 63.00 Others 62.00 Others Commerce 68.00 Comm&Mgmt No
## 51 51 F 75.20 Central 73.20 Central Science 68.40 Comm&Mgmt No
## 54 54 M 80.00 Others 70.00 Others Science 72.00 Sci&Tech No
## 55 55 F 74.00 Central 60.00 Others Science 69.00 Comm&Mgmt No
## 56 56 M 60.40 Central 66.60 Others Science 65.00 Comm&Mgmt No
## 57 57 M 63.00 Others 71.40 Others Commerce 61.40 Comm&Mgmt No
## 58 58 M 68.00 Central 76.00 Central Commerce 74.00 Comm&Mgmt No
## 59 59 M 74.00 Central 62.00 Others Science 68.00 Comm&Mgmt No
## 60 60 M 52.60 Central 65.58 Others Science 72.11 Sci&Tech No
## 61 61 M 74.00 Central 70.00 Central Science 72.00 Comm&Mgmt Yes
## 62 62 M 84.20 Central 73.40 Central Commerce 66.89 Comm&Mgmt No
## 63 63 F 86.50 Others 64.20 Others Science 67.40 Sci&Tech No
## 65 65 M 80.00 Others 73.00 Others Commerce 75.00 Comm&Mgmt No
## 67 67 M 83.00 Others 74.00 Others Science 66.00 Comm&Mgmt No
## 68 68 M 80.92 Others 78.50 Others Commerce 67.00 Comm&Mgmt No
## 70 70 M 73.00 Central 73.00 Central Science 66.00 Sci&Tech Yes
## 71 71 M 82.00 Others 61.00 Others Science 62.00 Sci&Tech No
## 72 72 M 75.00 Others 70.29 Others Commerce 71.00 Comm&Mgmt No
## 73 73 M 84.86 Others 67.00 Others Science 78.00 Comm&Mgmt No
## 74 74 M 64.60 Central 83.83 Others Commerce 71.72 Comm&Mgmt No
## 75 75 M 56.60 Central 64.80 Central Commerce 70.20 Comm&Mgmt No
## 77 77 F 66.50 Others 70.40 Central Arts 71.93 Comm&Mgmt No
## 78 78 M 64.00 Others 80.00 Others Science 65.00 Sci&Tech Yes
## 79 79 M 84.00 Others 90.90 Others Science 64.50 Sci&Tech No
## 81 81 F 69.00 Others 62.00 Others Commerce 69.00 Comm&Mgmt Yes
## 82 82 M 81.70 Others 63.00 Others Science 67.00 Comm&Mgmt Yes
## 84 84 M 84.00 Others 79.00 Others Science 68.00 Sci&Tech Yes
## 85 85 M 70.00 Central 63.00 Others Science 70.00 Sci&Tech Yes
## 86 86 F 83.84 Others 89.83 Others Commerce 77.20 Comm&Mgmt Yes
## 87 87 M 62.00 Others 63.00 Others Commerce 64.00 Comm&Mgmt No
## 89 89 F 66.00 Central 62.00 Central Commerce 73.00 Comm&Mgmt No
## 90 90 F 84.00 Others 75.00 Others Science 69.00 Sci&Tech Yes
## 91 91 F 85.00 Others 90.00 Others Commerce 82.00 Comm&Mgmt No
## 93 93 F 60.23 Central 69.00 Central Science 66.00 Comm&Mgmt No
## 95 95 M 58.00 Central 62.00 Central Commerce 64.00 Comm&Mgmt No
## 96 96 M 73.00 Central 78.00 Others Commerce 65.00 Comm&Mgmt Yes
## 97 97 F 76.00 Central 70.00 Central Science 76.00 Comm&Mgmt Yes
## 99 99 F 69.00 Central 73.00 Central Commerce 65.00 Comm&Mgmt No
## 102 102 M 63.00 Central 72.00 Central Commerce 68.00 Comm&Mgmt No
## 103 103 F 77.00 Others 61.00 Others Commerce 68.00 Comm&Mgmt Yes
## 104 104 M 73.00 Central 78.00 Central Science 73.00 Sci&Tech Yes
## 105 105 M 69.00 Central 63.00 Others Science 65.00 Comm&Mgmt Yes
## 108 108 M 82.00 Others 90.00 Others Commerce 83.00 Comm&Mgmt No
## 109 109 M 61.00 Central 82.00 Central Commerce 69.00 Comm&Mgmt No
## 111 111 F 69.50 Central 70.00 Central Science 72.00 Sci&Tech No
## 113 113 M 58.00 Others 61.00 Others Commerce 61.00 Comm&Mgmt No
## 114 114 F 73.96 Others 79.00 Others Commerce 67.00 Comm&Mgmt No
## 115 115 M 65.00 Central 68.00 Others Science 69.00 Comm&Mgmt No
## 116 116 F 73.00 Others 63.00 Others Science 66.00 Comm&Mgmt No
## 117 117 M 68.20 Central 72.80 Central Commerce 66.60 Comm&Mgmt Yes
## 118 118 M 77.00 Others 75.00 Others Science 73.00 Sci&Tech No
## 119 119 M 76.00 Central 80.00 Central Science 78.00 Sci&Tech Yes
## 120 120 M 60.80 Central 68.40 Central Commerce 64.60 Comm&Mgmt Yes
## 122 122 F 64.00 Central 67.00 Others Science 69.60 Sci&Tech Yes
## 123 123 F 66.50 Central 66.80 Central Arts 69.30 Comm&Mgmt Yes
## 124 124 M 74.00 Others 59.00 Others Commerce 73.00 Comm&Mgmt Yes
## 125 125 M 67.00 Central 71.00 Central Science 64.33 Others Yes
## 126 126 F 84.00 Central 73.00 Central Commerce 73.00 Comm&Mgmt No
## 127 127 F 79.00 Others 61.00 Others Science 75.50 Sci&Tech Yes
## 128 128 F 72.00 Others 60.00 Others Science 69.00 Comm&Mgmt No
## 129 129 M 80.40 Central 73.40 Central Science 77.72 Sci&Tech Yes
## 130 130 M 76.70 Central 89.70 Others Commerce 66.00 Comm&Mgmt Yes
## 132 132 F 74.90 Others 57.00 Others Science 62.00 Others Yes
## 133 133 M 67.00 Others 68.00 Others Commerce 64.00 Comm&Mgmt Yes
## 134 134 M 73.00 Central 64.00 Others Commerce 77.00 Comm&Mgmt Yes
## 135 135 F 77.44 Central 92.00 Others Commerce 72.00 Comm&Mgmt Yes
## 136 136 F 72.00 Central 56.00 Others Science 69.00 Comm&Mgmt No
## 138 138 M 67.00 Others 63.00 Central Commerce 72.00 Comm&Mgmt No
## 139 139 F 82.00 Others 64.00 Others Science 73.00 Sci&Tech Yes
## 140 140 M 77.00 Central 70.00 Central Commerce 59.00 Comm&Mgmt Yes
## 141 141 M 65.00 Central 64.80 Others Commerce 69.50 Comm&Mgmt Yes
## 143 143 M 85.00 Central 60.00 Others Science 73.43 Sci&Tech Yes
## 144 144 M 77.67 Others 64.89 Others Commerce 70.67 Comm&Mgmt No
## 146 146 M 89.40 Others 65.66 Others Science 71.25 Sci&Tech No
## 147 147 M 62.00 Central 63.00 Others Science 66.00 Comm&Mgmt No
## 148 148 M 70.00 Central 74.00 Central Commerce 65.00 Comm&Mgmt No
## 149 149 F 77.00 Central 86.00 Central Arts 56.00 Others No
## 151 151 M 71.00 Central 58.66 Central Science 58.00 Sci&Tech Yes
## 152 152 M 65.00 Central 65.00 Central Commerce 75.00 Comm&Mgmt No
## 153 153 F 75.40 Others 60.50 Central Science 84.00 Sci&Tech No
## 154 154 M 49.00 Others 59.00 Others Science 65.00 Sci&Tech Yes
## 155 155 M 53.00 Central 63.00 Others Science 60.00 Comm&Mgmt Yes
## 157 157 M 84.20 Central 69.40 Central Science 65.00 Sci&Tech Yes
## 158 158 M 66.50 Central 62.50 Central Commerce 60.90 Comm&Mgmt No
## 161 161 M 87.00 Central 74.00 Central Science 65.00 Sci&Tech Yes
## 163 163 M 74.20 Central 87.60 Others Commerce 77.25 Comm&Mgmt Yes
## 164 164 M 63.00 Others 67.00 Others Science 64.00 Sci&Tech No
## 165 165 F 67.16 Central 72.50 Central Commerce 63.35 Comm&Mgmt No
## 167 167 M 62.00 Others 62.00 Others Commerce 60.00 Comm&Mgmt Yes
## 172 172 M 80.00 Others 80.00 Others Commerce 72.00 Comm&Mgmt Yes
## 173 173 M 73.00 Others 58.00 Others Commerce 56.00 Comm&Mgmt No
## 175 175 M 73.24 Others 50.83 Others Science 64.27 Sci&Tech Yes
## 177 177 F 59.00 Central 60.00 Others Commerce 56.00 Comm&Mgmt No
## 178 178 F 73.00 Central 97.00 Others Commerce 79.00 Comm&Mgmt Yes
## 179 179 M 68.00 Others 56.00 Others Science 68.00 Sci&Tech No
## 181 181 M 65.00 Central 71.50 Others Commerce 62.80 Comm&Mgmt Yes
## 184 184 M 65.00 Central 77.00 Central Commerce 69.00 Comm&Mgmt No
## 186 186 F 88.00 Central 72.00 Central Science 78.00 Others No
## 188 188 M 78.50 Central 65.50 Central Science 67.00 Sci&Tech Yes
## 192 192 M 67.00 Others 61.00 Central Science 72.00 Comm&Mgmt No
## 193 193 M 65.20 Central 61.40 Central Commerce 64.80 Comm&Mgmt Yes
## 194 194 F 60.00 Central 63.00 Central Arts 56.00 Others Yes
## 196 196 M 66.00 Central 76.00 Central Commerce 72.00 Comm&Mgmt Yes
## 197 197 M 72.00 Others 63.00 Others Science 77.50 Sci&Tech Yes
## 198 198 F 83.96 Others 53.00 Others Science 91.00 Sci&Tech No
## 200 200 M 69.00 Others 65.00 Others Commerce 57.00 Comm&Mgmt No
## 201 201 M 69.00 Others 60.00 Others Commerce 65.00 Comm&Mgmt No
## 203 203 M 70.00 Central 63.00 Central Science 66.00 Sci&Tech No
## 204 204 M 55.68 Others 61.33 Others Commerce 56.87 Comm&Mgmt No
## 205 205 F 74.00 Others 73.00 Others Commerce 73.00 Comm&Mgmt Yes
## 206 206 M 61.00 Others 62.00 Others Commerce 65.00 Comm&Mgmt No
## 208 208 M 83.33 Central 78.00 Others Commerce 61.00 Comm&Mgmt Yes
## 210 210 M 62.00 Central 72.00 Central Commerce 65.00 Comm&Mgmt No
## 211 211 M 80.60 Others 82.00 Others Commerce 77.60 Comm&Mgmt No
## 212 212 M 58.00 Others 60.00 Others Science 72.00 Sci&Tech No
## 213 213 M 67.00 Others 67.00 Others Commerce 73.00 Comm&Mgmt Yes
## 214 214 F 74.00 Others 66.00 Others Commerce 58.00 Comm&Mgmt No
## etest_p specialisation mba_p status salary
## 1 55.00 Mkt&HR 58.80 Placed 270000
## 2 86.50 Mkt&Fin 66.28 Placed 200000
## 3 75.00 Mkt&Fin 57.80 Placed 250000
## 5 96.80 Mkt&Fin 55.50 Placed 425000
## 8 67.00 Mkt&Fin 62.14 Placed 252000
## 9 91.34 Mkt&Fin 61.29 Placed 231000
## 11 62.00 Mkt&HR 60.85 Placed 260000
## 12 60.00 Mkt&Fin 63.70 Placed 250000
## 14 68.00 Mkt&Fin 68.63 Placed 218000
## 16 72.00 Mkt&Fin 64.66 Placed 200000
## 17 60.00 Mkt&Fin 62.54 Placed 300000
## 20 50.48 Mkt&Fin 77.89 Placed 236000
## 21 50.00 Mkt&HR 56.70 Placed 265000
## 22 95.00 Mkt&Fin 69.06 Placed 393000
## 23 55.53 Mkt&HR 68.81 Placed 360000
## 24 92.00 Mkt&Fin 63.62 Placed 300000
## 25 97.40 Mkt&Fin 74.01 Placed 360000
## 27 94.00 Mkt&Fin 57.55 Placed 240000
## 28 68.00 Mkt&HR 57.69 Placed 265000
## 29 73.35 Mkt&Fin 64.15 Placed 350000
## 31 52.00 Mkt&HR 56.70 Placed 250000
## 33 50.89 Mkt&HR 62.21 Placed 278000
## 34 88.00 Mkt&Fin 72.78 Placed 260000
## 36 71.00 Mkt&HR 62.74 Placed 300000
## 38 58.00 Mkt&HR 55.47 Placed 320000
## 39 53.70 Mkt&HR 56.86 Placed 240000
## 40 93.00 Mkt&Fin 62.56 Placed 411000
## 41 60.00 Mkt&Fin 66.72 Placed 287000
## 44 95.00 Mkt&HR 62.90 Placed 300000
## 45 89.00 Mkt&Fin 69.70 Placed 200000
## 48 78.00 Mkt&Fin 54.55 Placed 204000
## 49 64.00 Mkt&Fin 62.46 Placed 250000
## 51 65.00 Mkt&HR 62.98 Placed 200000
## 54 87.00 Mkt&HR 71.04 Placed 450000
## 55 78.00 Mkt&HR 65.56 Placed 216000
## 56 71.00 Mkt&HR 52.71 Placed 220000
## 57 68.00 Mkt&Fin 66.88 Placed 240000
## 58 80.00 Mkt&Fin 63.59 Placed 360000
## 59 74.00 Mkt&Fin 57.99 Placed 268000
## 60 57.60 Mkt&Fin 56.66 Placed 265000
## 61 60.00 Mkt&Fin 57.24 Placed 260000
## 62 61.60 Mkt&Fin 62.48 Placed 300000
## 63 59.00 Mkt&Fin 59.69 Placed 240000
## 65 61.00 Mkt&Fin 58.78 Placed 240000
## 67 68.92 Mkt&HR 58.46 Placed 275000
## 68 68.71 Mkt&Fin 60.99 Placed 275000
## 70 70.00 Mkt&Fin 68.07 Placed 275000
## 71 89.00 Mkt&Fin 65.45 Placed 360000
## 72 95.00 Mkt&Fin 66.94 Placed 240000
## 73 95.50 Mkt&Fin 68.53 Placed 240000
## 74 86.00 Mkt&Fin 59.75 Placed 218000
## 75 84.27 Mkt&Fin 67.20 Placed 336000
## 77 61.00 Mkt&Fin 64.27 Placed 230000
## 78 69.00 Mkt&Fin 57.65 Placed 500000
## 79 86.04 Mkt&Fin 59.42 Placed 270000
## 81 67.00 Mkt&HR 62.35 Placed 240000
## 82 86.00 Mkt&Fin 70.20 Placed 300000
## 84 84.00 Mkt&Fin 66.69 Placed 300000
## 85 55.00 Mkt&Fin 62.00 Placed 300000
## 86 78.74 Mkt&Fin 76.18 Placed 400000
## 87 67.00 Mkt&Fin 57.03 Placed 220000
## 89 58.00 Mkt&HR 64.36 Placed 210000
## 90 62.00 Mkt&HR 62.36 Placed 210000
## 91 92.00 Mkt&Fin 68.03 Placed 300000
## 93 72.00 Mkt&Fin 59.47 Placed 230000
## 95 53.88 Mkt&Fin 54.97 Placed 260000
## 96 95.46 Mkt&Fin 62.16 Placed 420000
## 97 66.00 Mkt&Fin 64.44 Placed 300000
## 99 70.00 Mkt&Fin 57.31 Placed 220000
## 102 78.00 Mkt&HR 60.44 Placed 380000
## 103 57.50 Mkt&Fin 61.31 Placed 300000
## 104 85.00 Mkt&HR 65.83 Placed 240000
## 105 55.00 Mkt&HR 58.23 Placed 360000
## 108 80.00 Mkt&HR 73.52 Placed 200000
## 109 84.00 Mkt&Fin 58.31 Placed 300000
## 111 57.20 Mkt&HR 54.80 Placed 250000
## 113 58.00 Mkt&HR 53.94 Placed 250000
## 114 72.15 Mkt&Fin 63.08 Placed 280000
## 115 53.70 Mkt&HR 55.01 Placed 250000
## 116 89.00 Mkt&Fin 60.50 Placed 216000
## 117 96.00 Mkt&Fin 70.85 Placed 300000
## 118 80.00 Mkt&Fin 67.05 Placed 240000
## 119 97.00 Mkt&HR 70.48 Placed 276000
## 120 82.66 Mkt&Fin 64.34 Placed 940000
## 122 55.67 Mkt&HR 71.49 Placed 250000
## 123 80.40 Mkt&Fin 71.00 Placed 236000
## 124 60.00 Mkt&HR 56.70 Placed 240000
## 125 64.00 Mkt&HR 61.26 Placed 250000
## 126 75.00 Mkt&Fin 73.33 Placed 350000
## 127 70.00 Mkt&Fin 68.20 Placed 210000
## 128 55.50 Mkt&HR 58.40 Placed 250000
## 129 81.20 Mkt&HR 76.26 Placed 400000
## 130 90.00 Mkt&Fin 68.55 Placed 250000
## 132 80.00 Mkt&Fin 60.78 Placed 360000
## 133 74.40 Mkt&HR 53.49 Placed 300000
## 134 65.00 Mkt&HR 60.98 Placed 250000
## 135 94.00 Mkt&Fin 67.13 Placed 250000
## 136 55.60 Mkt&HR 65.63 Placed 200000
## 138 56.00 Mkt&HR 60.41 Placed 225000
## 139 96.00 Mkt&Fin 71.77 Placed 250000
## 140 58.00 Mkt&Fin 54.43 Placed 220000
## 141 56.00 Mkt&Fin 56.94 Placed 265000
## 143 60.00 Mkt&Fin 61.29 Placed 260000
## 144 89.00 Mkt&Fin 60.39 Placed 300000
## 146 72.00 Mkt&HR 63.23 Placed 400000
## 147 85.00 Mkt&HR 55.14 Placed 233000
## 148 83.00 Mkt&Fin 62.28 Placed 300000
## 149 57.00 Mkt&Fin 64.08 Placed 240000
## 151 56.00 Mkt&Fin 61.30 Placed 690000
## 152 83.00 Mkt&Fin 58.87 Placed 270000
## 153 98.00 Mkt&Fin 65.25 Placed 240000
## 154 86.00 Mkt&Fin 62.48 Placed 340000
## 155 70.00 Mkt&Fin 53.20 Placed 250000
## 157 80.00 Mkt&HR 52.72 Placed 255000
## 158 93.40 Mkt&Fin 55.03 Placed 300000
## 161 75.00 Mkt&HR 72.29 Placed 300000
## 163 75.20 Mkt&Fin 66.06 Placed 285000
## 164 75.00 Mkt&Fin 66.46 Placed 500000
## 165 53.04 Mkt&Fin 65.52 Placed 250000
## 167 63.00 Mkt&HR 52.38 Placed 240000
## 172 63.79 Mkt&Fin 66.04 Placed 290000
## 173 84.00 Mkt&HR 52.64 Placed 300000
## 175 64.00 Mkt&Fin 66.23 Placed 500000
## 177 55.00 Mkt&HR 57.90 Placed 220000
## 178 89.00 Mkt&Fin 70.81 Placed 650000
## 179 73.00 Mkt&HR 68.07 Placed 350000
## 181 57.00 Mkt&Fin 56.60 Placed 265000
## 184 60.00 Mkt&HR 61.82 Placed 276000
## 186 82.00 Mkt&HR 71.43 Placed 252000
## 188 95.00 Mkt&Fin 64.86 Placed 280000
## 192 72.00 Mkt&Fin 61.01 Placed 264000
## 193 93.40 Mkt&Fin 57.34 Placed 270000
## 194 80.00 Mkt&HR 56.63 Placed 300000
## 196 84.00 Mkt&HR 58.95 Placed 275000
## 197 78.00 Mkt&Fin 54.48 Placed 250000
## 198 59.32 Mkt&HR 69.71 Placed 260000
## 200 73.00 Mkt&HR 55.80 Placed 265000
## 201 87.55 Mkt&Fin 52.81 Placed 300000
## 203 61.28 Mkt&HR 60.11 Placed 240000
## 204 66.00 Mkt&HR 58.30 Placed 260000
## 205 80.00 Mkt&Fin 67.69 Placed 210000
## 206 62.00 Mkt&Fin 56.81 Placed 250000
## 208 88.56 Mkt&Fin 71.55 Placed 300000
## 210 67.00 Mkt&Fin 56.49 Placed 216000
## 211 91.00 Mkt&Fin 74.49 Placed 400000
## 212 74.00 Mkt&Fin 53.62 Placed 275000
## 213 59.00 Mkt&Fin 69.72 Placed 295000
## 214 70.00 Mkt&HR 60.23 Placed 204000
pl[!complete.cases(pl), ]
## sl_no gender ssc_p ssc_b hsc_p hsc_b hsc_s degree_p degree_t workex
## 4 4 M 56.00 Central 52.00 Central Science 52.00 Sci&Tech No
## 6 6 M 55.00 Others 49.80 Others Science 67.25 Sci&Tech Yes
## 7 7 F 46.00 Others 49.20 Others Commerce 79.00 Comm&Mgmt No
## 10 10 M 58.00 Central 70.00 Central Commerce 61.00 Comm&Mgmt No
## 13 13 F 47.00 Central 55.00 Others Science 65.00 Comm&Mgmt No
## 15 15 M 62.00 Central 47.00 Central Commerce 50.00 Comm&Mgmt No
## 18 18 F 55.00 Central 67.00 Central Commerce 64.00 Comm&Mgmt No
## 19 19 F 63.00 Central 66.00 Central Commerce 64.00 Comm&Mgmt No
## 26 26 F 52.58 Others 54.60 Central Commerce 50.20 Comm&Mgmt Yes
## 30 30 M 62.00 Central 67.00 Central Commerce 58.00 Comm&Mgmt No
## 32 32 F 67.00 Central 53.00 Central Science 65.00 Sci&Tech No
## 35 35 M 62.00 Others 51.00 Others Science 52.00 Others No
## 37 37 M 51.00 Central 44.00 Central Commerce 57.00 Comm&Mgmt No
## 42 42 F 74.00 Others 63.16 Others Commerce 65.00 Comm&Mgmt Yes
## 43 43 M 49.00 Others 39.00 Central Science 65.00 Others No
## 46 46 F 76.00 Central 64.00 Central Science 72.00 Sci&Tech No
## 47 47 F 70.89 Others 71.98 Others Science 65.60 Comm&Mgmt No
## 50 50 F 50.00 Others 37.00 Others Arts 52.00 Others No
## 52 52 M 54.40 Central 61.12 Central Commerce 56.20 Comm&Mgmt No
## 53 53 F 40.89 Others 45.83 Others Commerce 53.00 Comm&Mgmt No
## 64 64 M 61.00 Others 70.00 Others Commerce 64.00 Comm&Mgmt No
## 66 66 M 54.00 Others 47.00 Others Science 57.00 Comm&Mgmt No
## 69 69 F 69.70 Central 47.00 Central Commerce 72.70 Sci&Tech No
## 76 76 F 59.00 Central 62.00 Others Commerce 77.50 Comm&Mgmt No
## 80 80 F 69.00 Central 62.00 Central Science 66.00 Sci&Tech No
## 83 83 M 63.00 Central 67.00 Central Commerce 74.00 Comm&Mgmt No
## 88 88 M 59.60 Central 51.00 Central Science 60.00 Others No
## 92 92 M 52.00 Central 57.00 Central Commerce 50.80 Comm&Mgmt No
## 94 94 M 52.00 Central 62.00 Central Commerce 54.00 Comm&Mgmt No
## 98 98 F 70.50 Central 62.50 Others Commerce 61.00 Comm&Mgmt No
## 100 100 M 54.00 Central 82.00 Others Commerce 63.00 Sci&Tech No
## 101 101 F 45.00 Others 57.00 Others Commerce 58.00 Comm&Mgmt Yes
## 106 106 M 59.00 Central 64.00 Others Science 58.00 Sci&Tech No
## 107 107 M 61.08 Others 50.00 Others Science 54.00 Sci&Tech No
## 110 110 M 52.00 Central 63.00 Others Science 65.00 Sci&Tech Yes
## 112 112 M 51.00 Others 54.00 Others Science 61.00 Sci&Tech No
## 121 121 M 58.00 Others 40.00 Others Science 59.00 Comm&Mgmt No
## 131 131 M 62.00 Central 65.00 Others Commerce 60.00 Comm&Mgmt No
## 137 137 F 47.00 Central 59.00 Central Arts 64.00 Comm&Mgmt No
## 142 142 M 66.00 Central 64.00 Central Science 60.00 Comm&Mgmt No
## 145 145 M 52.00 Others 50.00 Others Arts 61.00 Comm&Mgmt No
## 150 150 M 44.00 Central 58.00 Central Arts 55.00 Comm&Mgmt Yes
## 156 156 M 51.57 Others 74.66 Others Commerce 59.90 Comm&Mgmt Yes
## 159 159 M 67.00 Others 63.00 Others Science 64.00 Sci&Tech No
## 160 160 M 52.00 Central 49.00 Others Commerce 58.00 Comm&Mgmt No
## 162 162 M 55.60 Others 51.00 Others Commerce 57.50 Comm&Mgmt No
## 166 166 F 63.30 Central 78.33 Others Commerce 74.00 Comm&Mgmt No
## 168 168 M 67.90 Others 62.00 Others Science 67.00 Sci&Tech Yes
## 169 169 F 48.00 Central 51.00 Central Commerce 58.00 Comm&Mgmt Yes
## 170 170 M 59.96 Others 42.16 Others Science 61.26 Sci&Tech No
## 171 171 F 63.40 Others 67.20 Others Commerce 60.00 Comm&Mgmt No
## 174 174 F 52.00 Others 52.00 Others Science 55.00 Sci&Tech No
## 176 176 M 63.00 Others 62.00 Others Science 65.00 Sci&Tech No
## 180 180 F 77.80 Central 64.00 Central Science 64.20 Sci&Tech No
## 182 182 M 62.00 Central 60.33 Others Science 64.21 Sci&Tech No
## 183 183 M 52.00 Others 65.00 Others Arts 57.00 Others Yes
## 185 185 F 56.28 Others 62.83 Others Commerce 59.79 Comm&Mgmt No
## 187 187 F 52.00 Central 64.00 Central Commerce 61.00 Comm&Mgmt No
## 189 189 M 61.80 Others 47.00 Others Commerce 54.38 Comm&Mgmt No
## 190 190 F 54.00 Central 77.60 Others Commerce 69.20 Comm&Mgmt No
## 191 191 F 64.00 Others 70.20 Central Commerce 61.00 Comm&Mgmt No
## 195 195 M 52.00 Others 55.00 Others Commerce 56.30 Comm&Mgmt No
## 199 199 F 67.00 Central 70.00 Central Commerce 65.00 Others No
## 202 202 M 54.20 Central 63.00 Others Science 58.00 Comm&Mgmt No
## 207 207 M 41.00 Central 42.00 Central Science 60.00 Comm&Mgmt No
## 209 209 F 43.00 Central 60.00 Others Science 65.00 Comm&Mgmt No
## 215 215 M 62.00 Central 58.00 Others Science 53.00 Comm&Mgmt No
## etest_p specialisation mba_p status salary
## 4 66.00 Mkt&HR 59.43 Not Placed NA
## 6 55.00 Mkt&Fin 51.58 Not Placed NA
## 7 74.28 Mkt&Fin 53.29 Not Placed NA
## 10 54.00 Mkt&Fin 52.21 Not Placed NA
## 13 62.00 Mkt&HR 65.04 Not Placed NA
## 15 76.00 Mkt&HR 54.96 Not Placed NA
## 18 60.00 Mkt&Fin 67.28 Not Placed NA
## 19 68.00 Mkt&HR 64.08 Not Placed NA
## 26 76.00 Mkt&Fin 65.33 Not Placed NA
## 30 77.00 Mkt&Fin 51.29 Not Placed NA
## 32 64.00 Mkt&HR 58.32 Not Placed NA
## 35 68.44 Mkt&HR 62.77 Not Placed NA
## 37 64.00 Mkt&Fin 51.45 Not Placed NA
## 42 65.00 Mkt&HR 69.76 Not Placed NA
## 43 63.00 Mkt&Fin 51.21 Not Placed NA
## 46 58.00 Mkt&HR 66.53 Not Placed NA
## 47 68.00 Mkt&HR 71.63 Not Placed NA
## 50 65.00 Mkt&HR 56.11 Not Placed NA
## 52 67.00 Mkt&HR 62.65 Not Placed NA
## 53 71.20 Mkt&HR 65.49 Not Placed NA
## 64 68.50 Mkt&HR 59.50 Not Placed NA
## 66 89.69 Mkt&HR 57.10 Not Placed NA
## 69 79.00 Mkt&HR 59.24 Not Placed NA
## 76 74.00 Mkt&HR 67.00 Not Placed NA
## 80 75.00 Mkt&HR 67.99 Not Placed NA
## 83 82.00 Mkt&Fin 60.44 Not Placed NA
## 88 75.00 Mkt&HR 59.08 Not Placed NA
## 92 67.00 Mkt&HR 62.79 Not Placed NA
## 94 72.00 Mkt&HR 55.41 Not Placed NA
## 98 93.91 Mkt&Fin 69.03 Not Placed NA
## 100 50.00 Mkt&Fin 59.47 Not Placed NA
## 101 56.39 Mkt&HR 64.95 Not Placed NA
## 106 85.00 Mkt&HR 55.30 Not Placed NA
## 107 71.00 Mkt&Fin 65.69 Not Placed NA
## 110 86.00 Mkt&HR 56.09 Not Placed NA
## 112 60.00 Mkt&HR 60.64 Not Placed NA
## 121 73.00 Mkt&HR 58.81 Not Placed NA
## 131 84.00 Mkt&Fin 64.15 Not Placed NA
## 137 78.00 Mkt&Fin 61.58 Not Placed NA
## 142 60.00 Mkt&HR 61.90 Not Placed NA
## 145 60.00 Mkt&Fin 58.52 Not Placed NA
## 150 64.25 Mkt&HR 58.54 Not Placed NA
## 156 56.15 Mkt&HR 65.99 Not Placed NA
## 159 60.00 Mkt&Fin 61.87 Not Placed NA
## 160 62.00 Mkt&HR 60.59 Not Placed NA
## 162 57.63 Mkt&HR 62.72 Not Placed NA
## 166 80.00 Mkt&Fin 74.56 Not Placed NA
## 168 58.10 Mkt&Fin 75.71 Not Placed NA
## 169 60.00 Mkt&HR 58.79 Not Placed NA
## 170 54.48 Mkt&HR 65.48 Not Placed NA
## 171 58.06 Mkt&HR 69.28 Not Placed NA
## 174 67.00 Mkt&HR 59.32 Not Placed NA
## 176 87.50 Mkt&HR 60.69 Not Placed NA
## 180 75.50 Mkt&HR 72.14 Not Placed NA
## 182 63.00 Mkt&HR 60.02 Not Placed NA
## 183 75.00 Mkt&Fin 59.81 Not Placed NA
## 185 60.00 Mkt&HR 57.29 Not Placed NA
## 187 55.00 Mkt&Fin 62.93 Not Placed NA
## 189 57.00 Mkt&Fin 56.13 Not Placed NA
## 190 95.65 Mkt&Fin 66.94 Not Placed NA
## 191 50.00 Mkt&Fin 62.50 Not Placed NA
## 195 59.00 Mkt&Fin 64.74 Not Placed NA
## 199 88.00 Mkt&HR 71.96 Not Placed NA
## 202 79.00 Mkt&HR 58.44 Not Placed NA
## 207 97.00 Mkt&Fin 53.39 Not Placed NA
## 209 92.66 Mkt&HR 62.92 Not Placed NA
## 215 89.00 Mkt&HR 60.22 Not Placed NA
pl<-pl[complete.cases(pl), ]
print(pl)
## sl_no gender ssc_p ssc_b hsc_p hsc_b hsc_s degree_p degree_t workex
## 1 1 M 67.00 Others 91.00 Others Commerce 58.00 Sci&Tech No
## 2 2 M 79.33 Central 78.33 Others Science 77.48 Sci&Tech Yes
## 3 3 M 65.00 Central 68.00 Central Arts 64.00 Comm&Mgmt No
## 5 5 M 85.80 Central 73.60 Central Commerce 73.30 Comm&Mgmt No
## 8 8 M 82.00 Central 64.00 Central Science 66.00 Sci&Tech Yes
## 9 9 M 73.00 Central 79.00 Central Commerce 72.00 Comm&Mgmt No
## 11 11 M 58.00 Central 61.00 Central Commerce 60.00 Comm&Mgmt Yes
## 12 12 M 69.60 Central 68.40 Central Commerce 78.30 Comm&Mgmt Yes
## 14 14 F 77.00 Central 87.00 Central Commerce 59.00 Comm&Mgmt No
## 16 16 F 65.00 Central 75.00 Central Commerce 69.00 Comm&Mgmt Yes
## 17 17 M 63.00 Central 66.20 Central Commerce 65.60 Comm&Mgmt Yes
## 20 20 M 60.00 Others 67.00 Others Arts 70.00 Comm&Mgmt Yes
## 21 21 M 62.00 Others 65.00 Others Commerce 66.00 Comm&Mgmt No
## 22 22 F 79.00 Others 76.00 Others Commerce 85.00 Comm&Mgmt No
## 23 23 F 69.80 Others 60.80 Others Science 72.23 Sci&Tech No
## 24 24 F 77.40 Others 60.00 Others Science 64.74 Sci&Tech Yes
## 25 25 M 76.50 Others 97.70 Others Science 78.86 Sci&Tech No
## 27 27 M 71.00 Others 79.00 Others Commerce 66.00 Comm&Mgmt Yes
## 28 28 M 63.00 Others 67.00 Others Commerce 66.00 Comm&Mgmt No
## 29 29 M 76.76 Others 76.50 Others Commerce 67.50 Comm&Mgmt Yes
## 31 31 F 64.00 Central 73.50 Central Commerce 73.00 Comm&Mgmt No
## 33 33 F 61.00 Central 81.00 Central Commerce 66.40 Comm&Mgmt No
## 34 34 F 87.00 Others 65.00 Others Science 81.00 Comm&Mgmt Yes
## 36 36 F 69.00 Central 78.00 Central Commerce 72.00 Comm&Mgmt No
## 38 38 F 79.00 Central 76.00 Central Science 65.60 Sci&Tech No
## 39 39 F 73.00 Others 58.00 Others Science 66.00 Comm&Mgmt No
## 40 40 M 81.00 Others 68.00 Others Science 64.00 Sci&Tech No
## 41 41 F 78.00 Central 77.00 Others Commerce 80.00 Comm&Mgmt No
## 44 44 M 87.00 Others 87.00 Others Commerce 68.00 Comm&Mgmt No
## 45 45 F 77.00 Others 73.00 Others Commerce 81.00 Comm&Mgmt Yes
## 48 48 M 63.00 Central 60.00 Central Commerce 57.00 Comm&Mgmt Yes
## 49 49 M 63.00 Others 62.00 Others Commerce 68.00 Comm&Mgmt No
## 51 51 F 75.20 Central 73.20 Central Science 68.40 Comm&Mgmt No
## 54 54 M 80.00 Others 70.00 Others Science 72.00 Sci&Tech No
## 55 55 F 74.00 Central 60.00 Others Science 69.00 Comm&Mgmt No
## 56 56 M 60.40 Central 66.60 Others Science 65.00 Comm&Mgmt No
## 57 57 M 63.00 Others 71.40 Others Commerce 61.40 Comm&Mgmt No
## 58 58 M 68.00 Central 76.00 Central Commerce 74.00 Comm&Mgmt No
## 59 59 M 74.00 Central 62.00 Others Science 68.00 Comm&Mgmt No
## 60 60 M 52.60 Central 65.58 Others Science 72.11 Sci&Tech No
## 61 61 M 74.00 Central 70.00 Central Science 72.00 Comm&Mgmt Yes
## 62 62 M 84.20 Central 73.40 Central Commerce 66.89 Comm&Mgmt No
## 63 63 F 86.50 Others 64.20 Others Science 67.40 Sci&Tech No
## 65 65 M 80.00 Others 73.00 Others Commerce 75.00 Comm&Mgmt No
## 67 67 M 83.00 Others 74.00 Others Science 66.00 Comm&Mgmt No
## 68 68 M 80.92 Others 78.50 Others Commerce 67.00 Comm&Mgmt No
## 70 70 M 73.00 Central 73.00 Central Science 66.00 Sci&Tech Yes
## 71 71 M 82.00 Others 61.00 Others Science 62.00 Sci&Tech No
## 72 72 M 75.00 Others 70.29 Others Commerce 71.00 Comm&Mgmt No
## 73 73 M 84.86 Others 67.00 Others Science 78.00 Comm&Mgmt No
## 74 74 M 64.60 Central 83.83 Others Commerce 71.72 Comm&Mgmt No
## 75 75 M 56.60 Central 64.80 Central Commerce 70.20 Comm&Mgmt No
## 77 77 F 66.50 Others 70.40 Central Arts 71.93 Comm&Mgmt No
## 78 78 M 64.00 Others 80.00 Others Science 65.00 Sci&Tech Yes
## 79 79 M 84.00 Others 90.90 Others Science 64.50 Sci&Tech No
## 81 81 F 69.00 Others 62.00 Others Commerce 69.00 Comm&Mgmt Yes
## 82 82 M 81.70 Others 63.00 Others Science 67.00 Comm&Mgmt Yes
## 84 84 M 84.00 Others 79.00 Others Science 68.00 Sci&Tech Yes
## 85 85 M 70.00 Central 63.00 Others Science 70.00 Sci&Tech Yes
## 86 86 F 83.84 Others 89.83 Others Commerce 77.20 Comm&Mgmt Yes
## 87 87 M 62.00 Others 63.00 Others Commerce 64.00 Comm&Mgmt No
## 89 89 F 66.00 Central 62.00 Central Commerce 73.00 Comm&Mgmt No
## 90 90 F 84.00 Others 75.00 Others Science 69.00 Sci&Tech Yes
## 91 91 F 85.00 Others 90.00 Others Commerce 82.00 Comm&Mgmt No
## 93 93 F 60.23 Central 69.00 Central Science 66.00 Comm&Mgmt No
## 95 95 M 58.00 Central 62.00 Central Commerce 64.00 Comm&Mgmt No
## 96 96 M 73.00 Central 78.00 Others Commerce 65.00 Comm&Mgmt Yes
## 97 97 F 76.00 Central 70.00 Central Science 76.00 Comm&Mgmt Yes
## 99 99 F 69.00 Central 73.00 Central Commerce 65.00 Comm&Mgmt No
## 102 102 M 63.00 Central 72.00 Central Commerce 68.00 Comm&Mgmt No
## 103 103 F 77.00 Others 61.00 Others Commerce 68.00 Comm&Mgmt Yes
## 104 104 M 73.00 Central 78.00 Central Science 73.00 Sci&Tech Yes
## 105 105 M 69.00 Central 63.00 Others Science 65.00 Comm&Mgmt Yes
## 108 108 M 82.00 Others 90.00 Others Commerce 83.00 Comm&Mgmt No
## 109 109 M 61.00 Central 82.00 Central Commerce 69.00 Comm&Mgmt No
## 111 111 F 69.50 Central 70.00 Central Science 72.00 Sci&Tech No
## 113 113 M 58.00 Others 61.00 Others Commerce 61.00 Comm&Mgmt No
## 114 114 F 73.96 Others 79.00 Others Commerce 67.00 Comm&Mgmt No
## 115 115 M 65.00 Central 68.00 Others Science 69.00 Comm&Mgmt No
## 116 116 F 73.00 Others 63.00 Others Science 66.00 Comm&Mgmt No
## 117 117 M 68.20 Central 72.80 Central Commerce 66.60 Comm&Mgmt Yes
## 118 118 M 77.00 Others 75.00 Others Science 73.00 Sci&Tech No
## 119 119 M 76.00 Central 80.00 Central Science 78.00 Sci&Tech Yes
## 120 120 M 60.80 Central 68.40 Central Commerce 64.60 Comm&Mgmt Yes
## 122 122 F 64.00 Central 67.00 Others Science 69.60 Sci&Tech Yes
## 123 123 F 66.50 Central 66.80 Central Arts 69.30 Comm&Mgmt Yes
## 124 124 M 74.00 Others 59.00 Others Commerce 73.00 Comm&Mgmt Yes
## 125 125 M 67.00 Central 71.00 Central Science 64.33 Others Yes
## 126 126 F 84.00 Central 73.00 Central Commerce 73.00 Comm&Mgmt No
## 127 127 F 79.00 Others 61.00 Others Science 75.50 Sci&Tech Yes
## 128 128 F 72.00 Others 60.00 Others Science 69.00 Comm&Mgmt No
## 129 129 M 80.40 Central 73.40 Central Science 77.72 Sci&Tech Yes
## 130 130 M 76.70 Central 89.70 Others Commerce 66.00 Comm&Mgmt Yes
## 132 132 F 74.90 Others 57.00 Others Science 62.00 Others Yes
## 133 133 M 67.00 Others 68.00 Others Commerce 64.00 Comm&Mgmt Yes
## 134 134 M 73.00 Central 64.00 Others Commerce 77.00 Comm&Mgmt Yes
## 135 135 F 77.44 Central 92.00 Others Commerce 72.00 Comm&Mgmt Yes
## 136 136 F 72.00 Central 56.00 Others Science 69.00 Comm&Mgmt No
## 138 138 M 67.00 Others 63.00 Central Commerce 72.00 Comm&Mgmt No
## 139 139 F 82.00 Others 64.00 Others Science 73.00 Sci&Tech Yes
## 140 140 M 77.00 Central 70.00 Central Commerce 59.00 Comm&Mgmt Yes
## 141 141 M 65.00 Central 64.80 Others Commerce 69.50 Comm&Mgmt Yes
## 143 143 M 85.00 Central 60.00 Others Science 73.43 Sci&Tech Yes
## 144 144 M 77.67 Others 64.89 Others Commerce 70.67 Comm&Mgmt No
## 146 146 M 89.40 Others 65.66 Others Science 71.25 Sci&Tech No
## 147 147 M 62.00 Central 63.00 Others Science 66.00 Comm&Mgmt No
## 148 148 M 70.00 Central 74.00 Central Commerce 65.00 Comm&Mgmt No
## 149 149 F 77.00 Central 86.00 Central Arts 56.00 Others No
## 151 151 M 71.00 Central 58.66 Central Science 58.00 Sci&Tech Yes
## 152 152 M 65.00 Central 65.00 Central Commerce 75.00 Comm&Mgmt No
## 153 153 F 75.40 Others 60.50 Central Science 84.00 Sci&Tech No
## 154 154 M 49.00 Others 59.00 Others Science 65.00 Sci&Tech Yes
## 155 155 M 53.00 Central 63.00 Others Science 60.00 Comm&Mgmt Yes
## 157 157 M 84.20 Central 69.40 Central Science 65.00 Sci&Tech Yes
## 158 158 M 66.50 Central 62.50 Central Commerce 60.90 Comm&Mgmt No
## 161 161 M 87.00 Central 74.00 Central Science 65.00 Sci&Tech Yes
## 163 163 M 74.20 Central 87.60 Others Commerce 77.25 Comm&Mgmt Yes
## 164 164 M 63.00 Others 67.00 Others Science 64.00 Sci&Tech No
## 165 165 F 67.16 Central 72.50 Central Commerce 63.35 Comm&Mgmt No
## 167 167 M 62.00 Others 62.00 Others Commerce 60.00 Comm&Mgmt Yes
## 172 172 M 80.00 Others 80.00 Others Commerce 72.00 Comm&Mgmt Yes
## 173 173 M 73.00 Others 58.00 Others Commerce 56.00 Comm&Mgmt No
## 175 175 M 73.24 Others 50.83 Others Science 64.27 Sci&Tech Yes
## 177 177 F 59.00 Central 60.00 Others Commerce 56.00 Comm&Mgmt No
## 178 178 F 73.00 Central 97.00 Others Commerce 79.00 Comm&Mgmt Yes
## 179 179 M 68.00 Others 56.00 Others Science 68.00 Sci&Tech No
## 181 181 M 65.00 Central 71.50 Others Commerce 62.80 Comm&Mgmt Yes
## 184 184 M 65.00 Central 77.00 Central Commerce 69.00 Comm&Mgmt No
## 186 186 F 88.00 Central 72.00 Central Science 78.00 Others No
## 188 188 M 78.50 Central 65.50 Central Science 67.00 Sci&Tech Yes
## 192 192 M 67.00 Others 61.00 Central Science 72.00 Comm&Mgmt No
## 193 193 M 65.20 Central 61.40 Central Commerce 64.80 Comm&Mgmt Yes
## 194 194 F 60.00 Central 63.00 Central Arts 56.00 Others Yes
## 196 196 M 66.00 Central 76.00 Central Commerce 72.00 Comm&Mgmt Yes
## 197 197 M 72.00 Others 63.00 Others Science 77.50 Sci&Tech Yes
## 198 198 F 83.96 Others 53.00 Others Science 91.00 Sci&Tech No
## 200 200 M 69.00 Others 65.00 Others Commerce 57.00 Comm&Mgmt No
## 201 201 M 69.00 Others 60.00 Others Commerce 65.00 Comm&Mgmt No
## 203 203 M 70.00 Central 63.00 Central Science 66.00 Sci&Tech No
## 204 204 M 55.68 Others 61.33 Others Commerce 56.87 Comm&Mgmt No
## 205 205 F 74.00 Others 73.00 Others Commerce 73.00 Comm&Mgmt Yes
## 206 206 M 61.00 Others 62.00 Others Commerce 65.00 Comm&Mgmt No
## 208 208 M 83.33 Central 78.00 Others Commerce 61.00 Comm&Mgmt Yes
## 210 210 M 62.00 Central 72.00 Central Commerce 65.00 Comm&Mgmt No
## 211 211 M 80.60 Others 82.00 Others Commerce 77.60 Comm&Mgmt No
## 212 212 M 58.00 Others 60.00 Others Science 72.00 Sci&Tech No
## 213 213 M 67.00 Others 67.00 Others Commerce 73.00 Comm&Mgmt Yes
## 214 214 F 74.00 Others 66.00 Others Commerce 58.00 Comm&Mgmt No
## etest_p specialisation mba_p status salary
## 1 55.00 Mkt&HR 58.80 Placed 270000
## 2 86.50 Mkt&Fin 66.28 Placed 200000
## 3 75.00 Mkt&Fin 57.80 Placed 250000
## 5 96.80 Mkt&Fin 55.50 Placed 425000
## 8 67.00 Mkt&Fin 62.14 Placed 252000
## 9 91.34 Mkt&Fin 61.29 Placed 231000
## 11 62.00 Mkt&HR 60.85 Placed 260000
## 12 60.00 Mkt&Fin 63.70 Placed 250000
## 14 68.00 Mkt&Fin 68.63 Placed 218000
## 16 72.00 Mkt&Fin 64.66 Placed 200000
## 17 60.00 Mkt&Fin 62.54 Placed 300000
## 20 50.48 Mkt&Fin 77.89 Placed 236000
## 21 50.00 Mkt&HR 56.70 Placed 265000
## 22 95.00 Mkt&Fin 69.06 Placed 393000
## 23 55.53 Mkt&HR 68.81 Placed 360000
## 24 92.00 Mkt&Fin 63.62 Placed 300000
## 25 97.40 Mkt&Fin 74.01 Placed 360000
## 27 94.00 Mkt&Fin 57.55 Placed 240000
## 28 68.00 Mkt&HR 57.69 Placed 265000
## 29 73.35 Mkt&Fin 64.15 Placed 350000
## 31 52.00 Mkt&HR 56.70 Placed 250000
## 33 50.89 Mkt&HR 62.21 Placed 278000
## 34 88.00 Mkt&Fin 72.78 Placed 260000
## 36 71.00 Mkt&HR 62.74 Placed 300000
## 38 58.00 Mkt&HR 55.47 Placed 320000
## 39 53.70 Mkt&HR 56.86 Placed 240000
## 40 93.00 Mkt&Fin 62.56 Placed 411000
## 41 60.00 Mkt&Fin 66.72 Placed 287000
## 44 95.00 Mkt&HR 62.90 Placed 300000
## 45 89.00 Mkt&Fin 69.70 Placed 200000
## 48 78.00 Mkt&Fin 54.55 Placed 204000
## 49 64.00 Mkt&Fin 62.46 Placed 250000
## 51 65.00 Mkt&HR 62.98 Placed 200000
## 54 87.00 Mkt&HR 71.04 Placed 450000
## 55 78.00 Mkt&HR 65.56 Placed 216000
## 56 71.00 Mkt&HR 52.71 Placed 220000
## 57 68.00 Mkt&Fin 66.88 Placed 240000
## 58 80.00 Mkt&Fin 63.59 Placed 360000
## 59 74.00 Mkt&Fin 57.99 Placed 268000
## 60 57.60 Mkt&Fin 56.66 Placed 265000
## 61 60.00 Mkt&Fin 57.24 Placed 260000
## 62 61.60 Mkt&Fin 62.48 Placed 300000
## 63 59.00 Mkt&Fin 59.69 Placed 240000
## 65 61.00 Mkt&Fin 58.78 Placed 240000
## 67 68.92 Mkt&HR 58.46 Placed 275000
## 68 68.71 Mkt&Fin 60.99 Placed 275000
## 70 70.00 Mkt&Fin 68.07 Placed 275000
## 71 89.00 Mkt&Fin 65.45 Placed 360000
## 72 95.00 Mkt&Fin 66.94 Placed 240000
## 73 95.50 Mkt&Fin 68.53 Placed 240000
## 74 86.00 Mkt&Fin 59.75 Placed 218000
## 75 84.27 Mkt&Fin 67.20 Placed 336000
## 77 61.00 Mkt&Fin 64.27 Placed 230000
## 78 69.00 Mkt&Fin 57.65 Placed 500000
## 79 86.04 Mkt&Fin 59.42 Placed 270000
## 81 67.00 Mkt&HR 62.35 Placed 240000
## 82 86.00 Mkt&Fin 70.20 Placed 300000
## 84 84.00 Mkt&Fin 66.69 Placed 300000
## 85 55.00 Mkt&Fin 62.00 Placed 300000
## 86 78.74 Mkt&Fin 76.18 Placed 400000
## 87 67.00 Mkt&Fin 57.03 Placed 220000
## 89 58.00 Mkt&HR 64.36 Placed 210000
## 90 62.00 Mkt&HR 62.36 Placed 210000
## 91 92.00 Mkt&Fin 68.03 Placed 300000
## 93 72.00 Mkt&Fin 59.47 Placed 230000
## 95 53.88 Mkt&Fin 54.97 Placed 260000
## 96 95.46 Mkt&Fin 62.16 Placed 420000
## 97 66.00 Mkt&Fin 64.44 Placed 300000
## 99 70.00 Mkt&Fin 57.31 Placed 220000
## 102 78.00 Mkt&HR 60.44 Placed 380000
## 103 57.50 Mkt&Fin 61.31 Placed 300000
## 104 85.00 Mkt&HR 65.83 Placed 240000
## 105 55.00 Mkt&HR 58.23 Placed 360000
## 108 80.00 Mkt&HR 73.52 Placed 200000
## 109 84.00 Mkt&Fin 58.31 Placed 300000
## 111 57.20 Mkt&HR 54.80 Placed 250000
## 113 58.00 Mkt&HR 53.94 Placed 250000
## 114 72.15 Mkt&Fin 63.08 Placed 280000
## 115 53.70 Mkt&HR 55.01 Placed 250000
## 116 89.00 Mkt&Fin 60.50 Placed 216000
## 117 96.00 Mkt&Fin 70.85 Placed 300000
## 118 80.00 Mkt&Fin 67.05 Placed 240000
## 119 97.00 Mkt&HR 70.48 Placed 276000
## 120 82.66 Mkt&Fin 64.34 Placed 940000
## 122 55.67 Mkt&HR 71.49 Placed 250000
## 123 80.40 Mkt&Fin 71.00 Placed 236000
## 124 60.00 Mkt&HR 56.70 Placed 240000
## 125 64.00 Mkt&HR 61.26 Placed 250000
## 126 75.00 Mkt&Fin 73.33 Placed 350000
## 127 70.00 Mkt&Fin 68.20 Placed 210000
## 128 55.50 Mkt&HR 58.40 Placed 250000
## 129 81.20 Mkt&HR 76.26 Placed 400000
## 130 90.00 Mkt&Fin 68.55 Placed 250000
## 132 80.00 Mkt&Fin 60.78 Placed 360000
## 133 74.40 Mkt&HR 53.49 Placed 300000
## 134 65.00 Mkt&HR 60.98 Placed 250000
## 135 94.00 Mkt&Fin 67.13 Placed 250000
## 136 55.60 Mkt&HR 65.63 Placed 200000
## 138 56.00 Mkt&HR 60.41 Placed 225000
## 139 96.00 Mkt&Fin 71.77 Placed 250000
## 140 58.00 Mkt&Fin 54.43 Placed 220000
## 141 56.00 Mkt&Fin 56.94 Placed 265000
## 143 60.00 Mkt&Fin 61.29 Placed 260000
## 144 89.00 Mkt&Fin 60.39 Placed 300000
## 146 72.00 Mkt&HR 63.23 Placed 400000
## 147 85.00 Mkt&HR 55.14 Placed 233000
## 148 83.00 Mkt&Fin 62.28 Placed 300000
## 149 57.00 Mkt&Fin 64.08 Placed 240000
## 151 56.00 Mkt&Fin 61.30 Placed 690000
## 152 83.00 Mkt&Fin 58.87 Placed 270000
## 153 98.00 Mkt&Fin 65.25 Placed 240000
## 154 86.00 Mkt&Fin 62.48 Placed 340000
## 155 70.00 Mkt&Fin 53.20 Placed 250000
## 157 80.00 Mkt&HR 52.72 Placed 255000
## 158 93.40 Mkt&Fin 55.03 Placed 300000
## 161 75.00 Mkt&HR 72.29 Placed 300000
## 163 75.20 Mkt&Fin 66.06 Placed 285000
## 164 75.00 Mkt&Fin 66.46 Placed 500000
## 165 53.04 Mkt&Fin 65.52 Placed 250000
## 167 63.00 Mkt&HR 52.38 Placed 240000
## 172 63.79 Mkt&Fin 66.04 Placed 290000
## 173 84.00 Mkt&HR 52.64 Placed 300000
## 175 64.00 Mkt&Fin 66.23 Placed 500000
## 177 55.00 Mkt&HR 57.90 Placed 220000
## 178 89.00 Mkt&Fin 70.81 Placed 650000
## 179 73.00 Mkt&HR 68.07 Placed 350000
## 181 57.00 Mkt&Fin 56.60 Placed 265000
## 184 60.00 Mkt&HR 61.82 Placed 276000
## 186 82.00 Mkt&HR 71.43 Placed 252000
## 188 95.00 Mkt&Fin 64.86 Placed 280000
## 192 72.00 Mkt&Fin 61.01 Placed 264000
## 193 93.40 Mkt&Fin 57.34 Placed 270000
## 194 80.00 Mkt&HR 56.63 Placed 300000
## 196 84.00 Mkt&HR 58.95 Placed 275000
## 197 78.00 Mkt&Fin 54.48 Placed 250000
## 198 59.32 Mkt&HR 69.71 Placed 260000
## 200 73.00 Mkt&HR 55.80 Placed 265000
## 201 87.55 Mkt&Fin 52.81 Placed 300000
## 203 61.28 Mkt&HR 60.11 Placed 240000
## 204 66.00 Mkt&HR 58.30 Placed 260000
## 205 80.00 Mkt&Fin 67.69 Placed 210000
## 206 62.00 Mkt&Fin 56.81 Placed 250000
## 208 88.56 Mkt&Fin 71.55 Placed 300000
## 210 67.00 Mkt&Fin 56.49 Placed 216000
## 211 91.00 Mkt&Fin 74.49 Placed 400000
## 212 74.00 Mkt&Fin 53.62 Placed 275000
## 213 59.00 Mkt&Fin 69.72 Placed 295000
## 214 70.00 Mkt&HR 60.23 Placed 204000
sapply(pl, function (x){sum(is.na(x))})
## sl_no gender ssc_p ssc_b hsc_p
## 0 0 0 0 0
## hsc_b hsc_s degree_p degree_t workex
## 0 0 0 0 0
## etest_p specialisation mba_p status salary
## 0 0 0 0 0
## Dropping null values
clean.pl <- na.omit(pl)
### We Can Observe There Are No Missing Values
### Discriptive Analysis:
summary(pl)
## sl_no gender ssc_p ssc_b
## Min. : 1.00 Length:148 Min. :49.00 Length:148
## 1st Qu.: 57.75 Class :character 1st Qu.:65.00 Class :character
## Median :108.50 Mode :character Median :72.50 Mode :character
## Mean :106.88 Mean :71.72
## 3rd Qu.:153.25 3rd Qu.:78.12
## Max. :214.00 Max. :89.40
## hsc_p hsc_b hsc_s degree_p
## Min. :50.83 Length:148 Length:148 Min. :56.00
## 1st Qu.:63.00 Class :character Class :character 1st Qu.:65.00
## Median :68.00 Mode :character Mode :character Median :68.00
## Mean :69.93 Mean :68.74
## 3rd Qu.:75.25 3rd Qu.:72.42
## Max. :97.70 Max. :91.00
## degree_t workex etest_p specialisation
## Length:148 Length:148 Min. :50.00 Length:148
## Class :character Class :character 1st Qu.:60.00 Class :character
## Mode :character Mode :character Median :72.00 Mode :character
## Mean :73.24
## 3rd Qu.:85.00
## Max. :98.00
## mba_p status salary
## Min. :52.38 Length:148 Min. :200000
## 1st Qu.:57.77 Class :character 1st Qu.:240000
## Median :62.24 Mode :character Median :265000
## Mean :62.58 Mean :288655
## 3rd Qu.:66.76 3rd Qu.:300000
## Max. :77.89 Max. :940000
#Here we can look at the descriptive statistics for all the numerical variables minimum, maximum, 1st quartile, 3rd quartile, mean, median, and for categorical variable we look at the frequency count of it.
### structure of dataset
str(pl)
## 'data.frame': 148 obs. of 15 variables:
## $ sl_no : int 1 2 3 5 8 9 11 12 14 16 ...
## $ gender : chr "M" "M" "M" "M" ...
## $ ssc_p : num 67 79.3 65 85.8 82 ...
## $ ssc_b : chr "Others" "Central" "Central" "Central" ...
## $ hsc_p : num 91 78.3 68 73.6 64 ...
## $ hsc_b : chr "Others" "Others" "Central" "Central" ...
## $ hsc_s : chr "Commerce" "Science" "Arts" "Commerce" ...
## $ degree_p : num 58 77.5 64 73.3 66 ...
## $ degree_t : chr "Sci&Tech" "Sci&Tech" "Comm&Mgmt" "Comm&Mgmt" ...
## $ workex : chr "No" "Yes" "No" "No" ...
## $ etest_p : num 55 86.5 75 96.8 67 ...
## $ specialisation: chr "Mkt&HR" "Mkt&Fin" "Mkt&Fin" "Mkt&Fin" ...
## $ mba_p : num 58.8 66.3 57.8 55.5 62.1 ...
## $ status : chr "Placed" "Placed" "Placed" "Placed" ...
## $ salary : int 270000 200000 250000 425000 252000 231000 260000 250000 218000 200000 ...
#Here we can see variables datatype where some of them identified as character and some are integers,num respectively.
glimpse(pl)
## Rows: 148
## Columns: 15
## $ sl_no <int> 1, 2, 3, 5, 8, 9, 11, 12, 14, 16, 17, 20, 21, 22, 23, 2…
## $ gender <chr> "M", "M", "M", "M", "M", "M", "M", "M", "F", "F", "M", …
## $ ssc_p <dbl> 67.00, 79.33, 65.00, 85.80, 82.00, 73.00, 58.00, 69.60,…
## $ ssc_b <chr> "Others", "Central", "Central", "Central", "Central", "…
## $ hsc_p <dbl> 91.00, 78.33, 68.00, 73.60, 64.00, 79.00, 61.00, 68.40,…
## $ hsc_b <chr> "Others", "Others", "Central", "Central", "Central", "C…
## $ hsc_s <chr> "Commerce", "Science", "Arts", "Commerce", "Science", "…
## $ degree_p <dbl> 58.00, 77.48, 64.00, 73.30, 66.00, 72.00, 60.00, 78.30,…
## $ degree_t <chr> "Sci&Tech", "Sci&Tech", "Comm&Mgmt", "Comm&Mgmt", "Sci&…
## $ workex <chr> "No", "Yes", "No", "No", "Yes", "No", "Yes", "Yes", "No…
## $ etest_p <dbl> 55.00, 86.50, 75.00, 96.80, 67.00, 91.34, 62.00, 60.00,…
## $ specialisation <chr> "Mkt&HR", "Mkt&Fin", "Mkt&Fin", "Mkt&Fin", "Mkt&Fin", "…
## $ mba_p <dbl> 58.80, 66.28, 57.80, 55.50, 62.14, 61.29, 60.85, 63.70,…
## $ status <chr> "Placed", "Placed", "Placed", "Placed", "Placed", "Plac…
## $ salary <int> 270000, 200000, 250000, 425000, 252000, 231000, 260000,…
boxplot(pl$salary)

summary(pl$salary)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 200000 240000 265000 288655 300000 940000
x <- 300000 +(300000 -240000 )*1.5
pl$salary[pl$salary>x] = x
boxplot(pl$etest_p)

summary(pl$etest_p)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 50.00 60.00 72.00 73.24 85.00 98.00
x <- 85+(85-50 )*1.5
pl$etest_p[pl$etest_p>x] = x
boxplot(pl$mba_p)

summary(pl$mba_p)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 52.38 57.77 62.24 62.58 66.76 77.89
x <- 66.76+(66.76-57.77 )*1.5
pl$mba_p[pl$mba_p>x] = x
boxplot(pl$hsc_p)

summary(pl$hsc_p)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 50.83 63.00 68.00 69.93 75.25 97.70
x<-75.25+(75.25-63)*1.5
pl$hsc_p[pl$hsc_p>x] = x
boxplot(pl$ssc_p)

summary(pl$ssc_p)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 49.00 65.00 72.50 71.72 78.12 89.40
x<-78.25+(78.25-65)*1.5
pl$ssc_p[pl$ssc_p>x] = x
boxplot(pl$degree_p)

summary(pl$degree_p)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 56.00 65.00 68.00 68.74 72.42 91.00
x<-72+(72-65)*1.5
pl$degree_p[pl$degree_p>x] = x
#The points that are higher or lower than the whiskers of the boxplot are called outliers. Since none of the variables have points that are higher or lower than the whiskers of the boxplot, outlier treatment is not necessary in this instance.
#There are many ways to deal with outliers or extreme values, but the one we'll use here is whinsorization, in which the points above the whiskers are replaced with the maximum value of the boxplot and the points below the whiskers with the minimum value.The outlier treatment will be carried out in this manner.
hist(pl$ssc_p)

#The histogram above demonstrates that the majority of students scored between 60 and 70 percent in ssc public examination, while only a very small number scored 90 percent or higher.
hist(pl$hsc_p)

#The histogram above shows that most of understudies scored somewhere in the range of 60 and 65 percent in secondary school assessment, while just a tiny number scored 90% or higher.
hist(pl$degree_p)

##The histogram that can be seen above demonstrates that the majority of understudies achieved undergraduate scores between 65 and 70%, with just a small number attaining grades of 80% or higher.
hist(pl$etest_p)

#The Scores of Students Who Have Taken an Exam to Evaluate Their Potential in a Standard Role are Shown in the Histogram Above. The majority of students received scores between 55 and 60, while only a small number received scores between 95 and 100.
hist(pl$mba_p)

#The above histogram shows the mba students' scores, which show that most got scores between 60 and 65, and no one got more than 80 percent in post-graduation.
hist(pl$salary)

#The graph above shows how often students get paid after they get hired. We can see that the majority of students got paid between rs200,000 and rs300,000 per year, with about 15 students getting paid more than $400,000 per year.
library(plotly)
## Warning: package 'plotly' was built under R version 4.2.2
##
## Attaching package: 'plotly'
## The following object is masked from 'package:ggplot2':
##
## last_plot
## The following object is masked from 'package:stats':
##
## filter
## The following object is masked from 'package:graphics':
##
## layout
plot_ly(data=pl,x=pl$gender,type="histogram")
#The Above Graph Shows that majority of students who got placed are males when compared to females
plot_ly(data=pl,x=pl$specialisation,type="histogram")
#The graph above shows that the majority of students have completed their postgraduate studies in market and finance, which is double the number of students who have completed mkt and HR.
library(ggplot2)
ggplot(data=pl,aes(x=workex))+geom_bar()

#As evidenced by the bar graph above, the majority of students have no experience.
ggplot(data=pl,aes(x=hsc_b,fill=degree_t))+geom_bar()

# In India There are two types of board which students can choose to study(central and state board which is specified as others in the data set )in which it is displayed that in both of the boards have students with commerce and managment stream background
#Scatter Plot;
data<-pl[,c("salary","sl_no")]
d<-head(data)
plot(x=d$salary,y=d$sl_no,xlab="Salary Of Candidate",ylab="candidate no",main="candidate salary")

#The Above Scatter Plot Is Drawn Between salary of candidate and candidate number
ggplot(pl, aes(x = "", y =salary, fill = gender)) +
geom_bar(stat = "identity", color = "white") +
coord_polar("y", start = 0)+
theme_void()

#From The Above Diagram We Can Cunclude That Majority Of Men Have Got The Jobs And Getting The Salaries
p <- ggplot(data=pl)
a <- geom_point(aes(x=sl_no, y = ssc_p, color="Score" ),alpha=0.3)
b <- geom_point(aes(x=sl_no, y = hsc_p, color="Score"),alpha=0.3)
c <- geom_point(aes(x=sl_no, y = etest_p, color="Score"),alpha=0.3)
d <- geom_point(aes(x=sl_no, y = mba_p, color="Score"),alpha=0.3)
p + a+b+c+d + ylab("Score")

#From The Above Graph Shows That Many StudentsWho's s.no are from 100 and 150 got more than 90 score in total
a <- geom_smooth(aes(x=sl_no, y = ssc_p, color="Score" ),alpha=0.3)
b <- geom_smooth(aes(x=sl_no, y = hsc_p, color="Score"),alpha=0.3)
c <- geom_smooth(aes(x=sl_no, y = etest_p, color="Score"),alpha=0.3)
d <- geom_smooth(aes(x=sl_no, y = mba_p, color="Score"),alpha=0.3)
p + a+b+c+d + ylab("Score")
## `geom_smooth()` using method = 'loess' and formula 'y ~ x'
## `geom_smooth()` using method = 'loess' and formula 'y ~ x'
## `geom_smooth()` using method = 'loess' and formula 'y ~ x'
## `geom_smooth()` using method = 'loess' and formula 'y ~ x'
